﻿CREATE TABLE [dbo].[FloorUnit] (
    [Id]              INT             IDENTITY (1, 1) NOT NULL,
    [BlockFloorId]    INT             NOT NULL,
    [UnitNo]          VARCHAR (5)     NULL,
    [DoorPlateUnitNo] VARCHAR (5)     NULL,
    [Layout]          VARCHAR (5)     NULL,
    [FloorSize]       DECIMAL (18, 2) NULL,
    CONSTRAINT [PK_FloorUnit] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_FloorUnit_BlockFloor] FOREIGN KEY ([BlockFloorId]) REFERENCES [dbo].[BlockFloor] ([Id])
);

